Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00053707
You may apply to the job directly through the CAPPS Career Section. It is not necessary to apply both through Work In Texas and CAPPS Career Section
GENERAL DESCRIPTIONThe Office of the Attorney General (OAG) is a mission-driven organization with over 4,000 employees across Texas. We provide legal services to state agencies, combat human trafficking, support victims of crime, and operate one of the most effective Child Support Enforcement programs in the nation.This Data Engineer role is focused on enabling data-informed decision-making across administrative and legal teams by designing and developing interactive Tableau dashboards, building semantic data models, writing SQL queries, and constructing ETL pipelines. The position emphasizes strong analytical skills, data storytelling, and the ability to translate complex datasets into actionable insights. This role will ideally additionally help serve as a key enabler for artificial intelligence integration into analytics and business operations.The ideal candidate will have experience working with financial, operational, and legal datasets, and a passion for building scalable, self-service reporting solutions that promote transparency, efficiency, and data literacy across the agency. This role is highly collaborative, working in Agile teams to deliver value-driven, data-informed solutions that promote transparency, efficiency, and data literacy across the agency.The OAG is committed to providing innovative, modern, and value-driven IT services to the agency. We believe that having talented people in the right place while effectively utilizing new tools and technologies enables us to empower the agency to best serve the people of Texas. OAG employees enjoy excellent benefits along with tremendous opportunities to do important work at a large, dynamic state agency making a positive difference in the lives of Texans.ESSENTIAL POSITION FUNCTIONSAnalytics Visualization Developmentand#8226;Design and deliver dynamic Tableau dashboards and visualizations that provide actionable insights to support budgeting, financial planning, and legal operations.and#8226;Collaborate with stakeholders to gather requirements, define KPIs, and translate business needs into intuitive, data-driven solutions.and#8226;Build and maintain semantic layers and data models to support self-service analytics and consistent reporting.Data Preparation Analysisand#8226;Perform data wrangling, cleansing, and transformation using SQL and Python to prepare datasets for analysis and visualization.and#8226;Analyze large, complex datasets to uncover trends, anomalies, and actionable insights that inform agency decision-making.and#8226;Ensure data accuracy, consistency, and integrity across all reporting assets.ETL Development, Data Modeling, AI Enablementand#8226;Develop and maintain ETL pipelines to automate data ingestion and transformation processes.and#8226;Design and optimize data models that support efficient querying and reporting across multiple systems and domainsand#8226;Support the integration of AI-powered tools into analytics workflows, such as natural language querying, automated insights, and document summarization.Collaboration Agile Deliveryand#8226;Collaborate with cross-functional teams in an Agile environment to deliver high-impact, data-driven solutions aligned with business goals.and#8226;Promote best practices in data science, including reproducibility, model validation, documentation, and ethical data use.and#8226;Contribute to a culture of data literacy and democratization by enabling intuitive access to insights through well-structured semantic layers and visualizations.and#8226;Collaborate with IT and business teams to identify opportunities where AI tools can enhance reporting, data access, and decision-making.Risk Managementand#8226;Identify and mitigate potential risks associated with technology programs and projects, ensuring compliance with security and regulatory standards.and#8226;Assist in the risk management of data across the organization.and#8226;Proactively address issues and challenges that may impact project timelines or objectives.and#8226;Stay informed on emerging AI technologies and contribute to the agencyand#8217;s roadmap for responsible AI adoption.May lead, mentor and train others
Performs related work as assigned
Maintains relevant knowledge necessary to perform essential job functions
Attends work regularly in compliance with agreed-upon work schedule. Telework schedules are permitted for employees based on the agencyand#8217;s approved Telework Plan (if schedule does not adversely affect operations and service levels, and standard hours of operation are maintained).
Ensures security and confidentiality of sensitive and/or protected information
Complies with all agency policies and procedures, including those pertaining to ethics and integrity
Qualifications: MINIMUM QUALIFICATIONSData Scientist I:Education: Graduation from high school or equivalent
Education: Bachelorand#8217;s degree from an accredited four-year college/university; experience in the following (or closely related) fields may be substituted for the required education on a year-for-year basis: computer science, data engineering, information systems, mathematics, statistics, economics, or a related field
Experience: Four years of full-time experience in the following (or closely related) fields: computer science, data engineering, information systems, mathematics, statistics, economics, or a related field
Experience with developing in two or more of the following technologies: Tableau, Azure, SQL, R, Python, relational databases, ETL/ELT pipeline development, data modeling, semantic layer design, dashboard creation (e.g., Power BI), self-service reporting, REST APIs, or workflow automation
Knowledge of data quality principles, data validation techniques, and data governance best practices, including experience working with sensitive or regulated data and an understanding of data privacy, confidentiality, and security standards.
Skill in effective oral and written communication, including preparing and delivering technical presentations, status reports, and program-related updates to diverse audiences such as executive management, program staff, and external stakeholders; skill in exercising sound judgment, effective decision-making, and responding positively to constructive feedback
Skill in managing multiple priorities, meeting deadlines, and adapting to evolving requirements; ability to collaborate in a professional environment with cross-functional teams to ensure data quality, integrity, and alignment with agile-at-scale practices at the Office of the Attorney General
Ability to adapt to new technologies and learn quickly
Ability to meet position requirements, including on-site work at OAG locations, business-related travel, occasional extended hours in compliance with FLSA, and the physical ability to lift and relocate up to 10 lbs
Ability to travel up to 5%Data Scientist II and#8211; All of the above qualifications for a Data Scientist I, plus:Experience: One additional year of full-time experience in the following (or closely related) fields: computer science, data engineering, information systems, mathematics, statistics, economics, or a related fieldPREFERRED QUALIFICATIONSEducation: Major coursework in business intelligence, data engineering, data science, business analytics, computer science, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred
Experience: Strong expertise in Tableau and working with financial or